inherited FRelatorioConferenciaMovimento: TFRelatorioConferenciaMovimento
  Left = 226
  Top = 172
  Width = 994
  Height = 560
  Caption = 'ESTOQUE / RELAT'#211'RIOS'
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 16
  inherited Panel1: TPanel
    Width = 986
  end
  inherited Panel2: TPanel
    Width = 986
    Caption = 'CONSUMO POR CENTRO DE CUSTO - SINT'#201'TICO'
  end
  inherited GroupBox1: TGroupBox
    object Label3: TLabel
      Left = 19
      Top = 30
      Width = 91
      Height = 16
      Caption = 'Estoque / Local'
    end
    object Label4: TLabel
      Left = 19
      Top = 144
      Width = 90
      Height = 16
      Caption = 'Tipo Movimento'
    end
    object DBText2: TDBText
      Left = 129
      Top = 144
      Width = 115
      Height = 16
      DataField = 'TIPMOVEST_ENTRADASAIDA'
      DataSource = DSTipoMovimentoEstoque
    end
    object Label5: TLabel
      Left = 19
      Top = 245
      Width = 66
      Height = 16
      Caption = 'Documento'
    end
    object Label28: TLabel
      Left = 19
      Top = 198
      Width = 67
      Height = 16
      Caption = 'C'#243'digo (F8)'
    end
    object Label32: TLabel
      Left = 96
      Top = 198
      Width = 85
      Height = 16
      Caption = 'Descri'#231#227'o (F8)'
    end
    object DBLCBLocal: TDBLookupComboBox
      Left = 19
      Top = 46
      Width = 271
      Height = 22
      Ctl3D = False
      KeyField = 'LOC_CODIGO'
      ListField = 'LOC_DESCRICAO'
      ListSource = DSLocal
      ParentCtl3D = False
      TabOrder = 0
      OnKeyDown = DBLCBLocalKeyDown
    end
    object gbDataCadastro: TGroupBox
      Left = 307
      Top = 19
      Width = 219
      Height = 54
      Caption = ' Per'#237'odo (Data Lancamento) '
      TabOrder = 1
      object Label6: TLabel
        Left = 105
        Top = 22
        Width = 7
        Height = 16
        Caption = 'a'
        Font.Charset = ANSI_CHARSET
        Font.Color = clWindowText
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object edDataIni: TDateEdit
        Left = 8
        Top = 21
        Width = 90
        Height = 21
        NumGlyphs = 2
        TabOrder = 0
      end
      object edDataFim: TDateEdit
        Left = 118
        Top = 21
        Width = 90
        Height = 21
        NumGlyphs = 2
        TabOrder = 1
      end
    end
    object DBLCBTipoMovimento: TDBLookupComboBox
      Left = 19
      Top = 163
      Width = 302
      Height = 22
      Ctl3D = False
      DataField = 'MOVEST_TIPOMOVIMENTO'
      KeyField = 'TIPMOVEST_CODIGO'
      ListField = 'TIPMOVEST_DESCRICAO'
      ListSource = DSTipoMovimentoEstoque
      ParentCtl3D = False
      TabOrder = 3
      OnKeyDown = DBLCBTipoMovimentoKeyDown
    end
    object EdDocumento: TEdit
      Left = 19
      Top = 263
      Width = 73
      Height = 22
      TabOrder = 4
    end
    object DBLCBProduto: TDBLookupComboBox
      Left = 96
      Top = 216
      Width = 369
      Height = 22
      Hint = '(F3) Visualizar Descri'#231#227'o'
      Ctl3D = False
      KeyField = 'PROD_CODIGO'
      ListField = 'PROD_DESCRICAOSAI'
      ListSource = DSProduto
      ParentCtl3D = False
      TabOrder = 5
      OnKeyDown = DBLCBProdutoKeyDown
    end
    object EdCodProduto: TEdit
      Left = 19
      Top = 216
      Width = 73
      Height = 22
      TabOrder = 6
      OnExit = EdCodProdutoExit
      OnKeyDown = EdCodProdutoKeyDown
    end
    object GroupBox3: TGroupBox
      Left = 10
      Top = 73
      Width = 517
      Height = 68
      Caption = '  Centro de Custo  '
      TabOrder = 2
      object Label7: TLabel
        Left = 10
        Top = 18
        Width = 40
        Height = 16
        Caption = 'C'#243'digo'
      end
      object Label16: TLabel
        Left = 85
        Top = 20
        Width = 85
        Height = 16
        Caption = 'Descri'#231#227'o (F8)'
      end
      object edCodCentroCusto: TEdit
        Left = 10
        Top = 37
        Width = 67
        Height = 22
        TabOrder = 0
        OnExit = edCodCentroCustoExit
      end
      object DBLCBCentroCusto: TDBLookupComboBox
        Left = 85
        Top = 38
        Width = 420
        Height = 22
        Ctl3D = False
        KeyField = 'ESTRUTURA'
        ListField = 'DESCRICAO'
        ListSource = dsCentroCusto
        ParentCtl3D = False
        TabOrder = 1
        OnExit = DBLCBCentroCustoExit
        OnKeyDown = DBLCBCentroCustoKeyDown
      end
    end
    object GroupBox4: TGroupBox
      Left = 104
      Top = 248
      Width = 425
      Height = 57
      Caption = '  Tipo Carroceria  '
      TabOrder = 7
      object cbALO: TCheckBox
        Left = 8
        Top = 24
        Width = 97
        Height = 17
        Caption = 'Alongado'
        TabOrder = 0
      end
      object cbCON: TCheckBox
        Left = 128
        Top = 24
        Width = 97
        Height = 17
        Caption = 'Convencional'
        TabOrder = 1
      end
      object cbART: TCheckBox
        Left = 280
        Top = 24
        Width = 97
        Height = 17
        Caption = 'Articulado'
        TabOrder = 2
      end
    end
  end
  inherited GroupBox2: TGroupBox
    Caption = ''
  end
  inherited RLReport: TRLReport
    Left = 24
    Top = 421
    DataSource = DSPesquisa
    Margins.LeftMargin = 5
    Margins.RightMargin = 5
    inherited RLBand1: TRLBand
      Left = 19
      Width = 756
    end
    object RLBand2: TRLBand
      Left = 19
      Top = 120
      Width = 756
      Height = 17
      BandType = btColumnHeader
      object RLLabel1: TRLLabel
        Left = 0
        Top = 0
        Width = 127
        Height = 16
        Caption = 'CENTRO DE CUSTO'
      end
      object RLLabel2: TRLLabel
        Left = 688
        Top = 0
        Width = 66
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        Caption = 'Vr. L'#237'quido'
      end
      object RLLabel3: TRLLabel
        Left = 594
        Top = 0
        Width = 58
        Height = 16
        Alignment = taRightJustify
        Caption = 'Vr. Sa'#237'da'
      end
      object RLLabel4: TRLLabel
        Left = 482
        Top = 0
        Width = 70
        Height = 16
        Alignment = taRightJustify
        Caption = 'Vr. Entrada'
      end
    end
    object RLBand3: TRLBand
      Left = 19
      Top = 137
      Width = 756
      Height = 17
      object RLDBText2: TRLDBText
        Left = 0
        Top = 0
        Width = 33
        Height = 16
        AutoSize = False
        DataField = 'CODIGOCENTROCUSTO'
        DataSource = DSPesquisa
      end
      object RLDBText3: TRLDBText
        Left = 467
        Top = 0
        Width = 85
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        DataField = 'DEVOLUCAO'
        DataSource = DSPesquisa
      end
      object RLDBText4: TRLDBText
        Left = 557
        Top = 0
        Width = 95
        Height = 16
        Alignment = taRightJustify
        DataField = 'VALOR_TOTAL'
        DataSource = DSPesquisa
      end
      object RLDBText5: TRLDBText
        Left = 40
        Top = 0
        Width = 409
        Height = 16
        AutoSize = False
        DataField = 'DESCRICAO'
        DataSource = DSPesquisa
      end
      object RLLabel5: TRLLabel
        Left = 656
        Top = 0
        Width = 98
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        BeforePrint = RLLabel5BeforePrint
      end
    end
    object RLBand4: TRLBand
      Left = 19
      Top = 154
      Width = 756
      Height = 18
      BandType = btSummary
      object RLDBResult1: TRLDBResult
        Left = 467
        Top = 0
        Width = 85
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = True
        Borders.DrawRight = False
        Borders.DrawBottom = False
        DataField = 'DEVOLUCAO'
        DataSource = DSPesquisa
        Info = riSum
      end
      object RLDBResult2: TRLDBResult
        Left = 557
        Top = 0
        Width = 95
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = True
        Borders.DrawRight = False
        Borders.DrawBottom = False
        DataField = 'VALOR_TOTAL'
        DataSource = DSPesquisa
        Info = riSum
      end
      object RLLabel6: TRLLabel
        Left = 656
        Top = 0
        Width = 98
        Height = 16
        Alignment = taRightJustify
        AutoSize = False
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = True
        Borders.DrawRight = False
        Borders.DrawBottom = False
        BeforePrint = RLLabel6BeforePrint
      end
      object RLLabel7: TRLLabel
        Left = 360
        Top = 1
        Width = 36
        Height = 16
        Caption = 'Total:'
      end
    end
  end
  inherited QPesquisa: TQuery
    Active = True
    SQL.Strings = (
      'SELECT'
      '  CENTROCUSTO.CODIGOCENTROCUSTO,'
      '  CENTROCUSTO.DESCRICAO,'
      '  CENTROCUSTO.TIPO_CHASSI,'
      '  CENTROCUSTO.TIPO_CARROCEIA,'
      
        '  SUM(ITENSMOVIMENTOESTOQUE.ITENSMOVEST_QUANTIDADE * ITENSMOVIME' +
        'NTOESTOQUE.ITENSMOVEST_VALORC) AS VALOR_TOTAL,'
      '  ('
      '    SELECT'
      
        '      COALESCE(SUM(ITENSMOVIMENTOESTOQUE.ITENSMOVEST_QUANTIDADE ' +
        '* ITENSMOVIMENTOESTOQUE.ITENSMOVEST_VALORC),0)'
      '    FROM'
      '      MOVIMENTOESTOQUE'
      
        '      INNER JOIN CENTROCUSTO ON (MOVIMENTOESTOQUE.MOVEST_CENTROC' +
        'USTO = CENTROCUSTO.CODIGO)'
      
        '      INNER JOIN ITENSMOVIMENTOESTOQUE ON (MOVIMENTOESTOQUE.MOVE' +
        'ST_CODIGO = ITENSMOVIMENTOESTOQUE.ITENSMOVEST_MOVIMENTOESTOQUE)'
      
        '      INNER JOIN TIPOMOVIMENTOESTOQUE ON (MOVIMENTOESTOQUE.MOVES' +
        'T_TIPOMOVIMENTO = TIPOMOVIMENTOESTOQUE.TIPMOVEST_CODIGO)'
      '    WHERE'
      
        '      (TIPOMOVIMENTOESTOQUE.TIPMOVEST_ENTRADASAIDA = '#39'Entrada'#39')A' +
        'ND'
      '      (MOVIMENTOESTOQUE.MOVEST_CENTROCUSTO = CC.CODIGO)'
      '      '
      '  ) AS DEVOLUCAO'
      'FROM'
      '  MOVIMENTOESTOQUE'
      
        '  INNER JOIN CENTROCUSTO CC ON (MOVIMENTOESTOQUE.MOVEST_CENTROCU' +
        'STO = CC.CODIGO)'
      
        '  INNER JOIN ITENSMOVIMENTOESTOQUE ON (MOVIMENTOESTOQUE.MOVEST_C' +
        'ODIGO = ITENSMOVIMENTOESTOQUE.ITENSMOVEST_MOVIMENTOESTOQUE)'
      
        '  INNER JOIN TIPOMOVIMENTOESTOQUE ON (MOVIMENTOESTOQUE.MOVEST_TI' +
        'POMOVIMENTO = TIPOMOVIMENTOESTOQUE.TIPMOVEST_CODIGO)'
      'WHERE'
      '  TIPOMOVIMENTOESTOQUE.TIPMOVEST_ENTRADASAIDA = '#39'Saida'#39
      'GROUP BY'
      '  CENTROCUSTO.CODIGO,'
      '  CENTROCUSTO.DESCRICAO,'
      '  CENTROCUSTO.CODIGOCENTROCUSTO,'
      '  CENTROCUSTO.TIPO_CHASSI,'
      '  CENTROCUSTO.TIPO_CARROCEIA')
    Left = 600
    Top = 137
    object QPesquisaCODIGOCENTROCUSTO: TStringField
      FieldName = 'CODIGOCENTROCUSTO'
      Size = 30
    end
    object QPesquisaDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      Size = 100
    end
    object QPesquisaTIPO_CARROCEIA: TStringField
      FieldName = 'TIPO_CARROCEIA'
      FixedChar = True
      Size = 3
    end
    object QPesquisaVALOR_TOTAL: TFloatField
      FieldName = 'VALOR_TOTAL'
      DisplayFormat = '#,##0.00'
    end
    object QPesquisaDEVOLUCAO: TFloatField
      FieldName = 'DEVOLUCAO'
      DisplayFormat = '#,##0.00'
    end
  end
  inherited DSPesquisa: TDataSource
    Left = 656
    Top = 142
  end
  inherited RLDraftFilter: TRLDraftFilter
    Left = 240
  end
  inherited RLHTMLFilter1: TRLHTMLFilter
    Left = 272
  end
  inherited RLXLSFilter: TRLXLSFilter
    Left = 304
  end
  inherited RLPDFFilter: TRLPDFFilter
    Left = 336
  end
  object DSTipoMovimentoEstoque: TDataSource
    DataSet = DMGestao.QTipoMovimentoEstoque
    Left = 360
    Top = 144
  end
  object DSProduto: TDataSource
    DataSet = DMGestao.QProdutoEnt
    Left = 512
    Top = 248
  end
  object QLocal: TQuery
    Active = True
    DatabaseName = 'base'
    SQL.Strings = (
      'select '
      '  * '
      'from '
      '  Local'
      'WHERE'
      '  (EXCLUIDO <> '#39'S'#39') or (EXCLUIDO IS NULL)'
      'Order By Loc_Descricao;')
    Left = 360
    Top = 192
  end
  object DSLocal: TDataSource
    DataSet = QLocal
    Left = 360
    Top = 104
  end
  object dsCentroCusto: TDataSource
    DataSet = QCentro
    Left = 488
    Top = 136
  end
  object QCentro: TQuery
    Active = True
    DatabaseName = 'base'
    SQL.Strings = (
      'select * from Centrocusto'
      ''
      'where Codpai <> 0'
      ''
      'Order By Estrutura')
    Left = 548
    Top = 132
  end
end
